UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tjGdn+DJzHPFYTlMsb7jkxstxhj66imjMXz95o6UIWU='
WHERE
key_id = '2d47a117264e39193a71be65c7342bd24b9a6baa3503fbbff6093a772b1a5ac4'
AND (
token = 'tjGdn+DJzHPFYTlMsb7jkxstxhj66imjMXz95o6UIWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)