UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJpDlbHMqSL9bXpC8xFFYCpqxxe9B/jCeoiXXXeDeEA='
WHERE
key_id = '171eab0ea1ebc89f5e906eb6c807f2c89252afa08182e1ab8555957c3917d184'
AND (
token = 'ZJpDlbHMqSL9bXpC8xFFYCpqxxe9B/jCeoiXXXeDeEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)