UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9lhv1i5i4piQiZFRSh3bm7iNlYZIstfCQiBMb3cFSgg='
WHERE
key_id = '8802ba6c5688a0512856d9d0ee1021876cd5ab9831811fcb3832df0773de46a2'
AND (
token = '9lhv1i5i4piQiZFRSh3bm7iNlYZIstfCQiBMb3cFSgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)