UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hBYveSzr81uedO8+hLOiGwgfafV0SZtVVPBK6M4S0gk='
WHERE
key_id = 'a2231385eb7cb728975cebfe1cba71a24f5ba259f30679cc84b2a5d1ae2cfd22'
AND (
token = 'hBYveSzr81uedO8+hLOiGwgfafV0SZtVVPBK6M4S0gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)