UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f3CeUI7CNMb4gGRhXnvO8hBFubKW7u5QKEN+Klj0KUE='
WHERE
key_id = '509f9f5971d59a76c04ba6e87487d2a13b5c6719c53cae9780776711ad6453b3'
AND (
token = 'f3CeUI7CNMb4gGRhXnvO8hBFubKW7u5QKEN+Klj0KUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)