UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cuc0xAXaiElIe1BYSUE5D9JBLgJj1rV4nHyHnSO/xpg='
WHERE
key_id = 'b073f17a894bc371b3368ff24f6eb72774212bb04b92a8d74097380fce713646'
AND (
token = 'cuc0xAXaiElIe1BYSUE5D9JBLgJj1rV4nHyHnSO/xpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)