UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZF6D0la8mVgscPzseMQI8EXpmnQ44J+C3vll+qsCD88='
WHERE
key_id = '826e814879eba4744decf12b6e3760fe08ccb94e8545daa1203be71f2af9a6a1'
AND (
token = 'ZF6D0la8mVgscPzseMQI8EXpmnQ44J+C3vll+qsCD88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)