UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R+fXE4zFBpY5IzK+J+F1ZBgIz955kzWZAQen6hpdXOA='
WHERE
key_id = '9fa8b9fe86936e2181faf3251bd01814f26e18aa6f9c87dc4f64a1ded8762659'
AND (
token = 'R+fXE4zFBpY5IzK+J+F1ZBgIz955kzWZAQen6hpdXOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)