UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPHA6JVmR8fV4kPagBWFmr0eN+cI0LW5zpeejm2tmGg='
WHERE
key_id = 'baff017dd5272ee8934580aea0023aa29a2d8024a718589801a422ff0cc7ce72'
AND (
token = 'XPHA6JVmR8fV4kPagBWFmr0eN+cI0LW5zpeejm2tmGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)