UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zEYt8pBtHD8abOFSMezsZs0GA3L3vJTKQVgO9v2xHg='
WHERE
key_id = '215ace780fbf26ef2438127b2b4abb9bf393784630fd4c719420d60ad412835a'
AND (
token = '8zEYt8pBtHD8abOFSMezsZs0GA3L3vJTKQVgO9v2xHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)