UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7tFnjGVb4idokgQ8r3+lXlcpvmHJhn7fn7keEqldXI='
WHERE
key_id = '123ac73fac993ec6f745777b2e9ec635b0f7ee6470cd01dc11d17cdbba481bbf'
AND (
token = 'X7tFnjGVb4idokgQ8r3+lXlcpvmHJhn7fn7keEqldXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)