UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SdQ1s/O6iLxLQJfg7amTtBWwYk+8vZu5GLBofd+xl4s='
WHERE
key_id = 'ffdfcafa5446ee8de4f0c66b16f89ad0f51087514dce98c754b2ca104c02467b'
AND (
token = 'SdQ1s/O6iLxLQJfg7amTtBWwYk+8vZu5GLBofd+xl4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)