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