UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'shcL2iHWtGYM6BfZb4YGOAYV4KU51GRtLhXRsPTuFyU='
WHERE
key_id = '0e84fe668bd3bd98a48870a4297a4fad7a49ce73007ca1247a4839042361403c'
AND (
token = 'shcL2iHWtGYM6BfZb4YGOAYV4KU51GRtLhXRsPTuFyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)