UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8L0dYJFmtPXMhgBP+uESALBA0CtdLwL3YQtZB3GOp+w='
WHERE
key_id = '4f952a1b08c0d174f0508218459eceb643c1a7fe0171113354d17e686ee6c8d8'
AND (
token = '8L0dYJFmtPXMhgBP+uESALBA0CtdLwL3YQtZB3GOp+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)