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