UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPE7wFUiEgQ7wXiXA3DZ5/1p+Rfq5hrxmYQvUS7qdAA='
WHERE
key_id = '5c39cb3a109aa38e6c43cda9669794df9fdbf55965e8d5359685b59b1a13160c'
AND (
token = 'sPE7wFUiEgQ7wXiXA3DZ5/1p+Rfq5hrxmYQvUS7qdAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)