UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4J6UcUva1vvWmW1yrHYZJp3wtgbbKPcQyCULgHAWDYA='
WHERE
key_id = '4f93539b136791c0d16b89d68deb2d5514bb81828e5bec9e8b305c4b81395ec5'
AND (
token = '4J6UcUva1vvWmW1yrHYZJp3wtgbbKPcQyCULgHAWDYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)