UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NeZDJkxMajk4ygeLCtIYdDzaO5xgldFSJYid4nWPxOk='
WHERE
key_id = 'a6b859b53a78535a19655c3d1a14c3c95f2c4351d453093447fb1dcba71fb9a6'
AND (
token = 'NeZDJkxMajk4ygeLCtIYdDzaO5xgldFSJYid4nWPxOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)