UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kAWORjRRvPjzxXeS1GYvruDFn3hypmZyTOKY5D5YtgY='
WHERE
key_id = '046513233fdd0fcbe6173da13783ff580aca50b23c481416c89b9def229ad6f2'
AND (
token = 'kAWORjRRvPjzxXeS1GYvruDFn3hypmZyTOKY5D5YtgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)