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