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