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