UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'isT8mG+J8VOlEexqGX5zm6Mgdjzw1p1plzwgULOTnbY='
WHERE
key_id = '02b628276067f391016767e2c117a63070f09cb0e61e7378d012c1e5b3a8ae20'
AND (
token = 'isT8mG+J8VOlEexqGX5zm6Mgdjzw1p1plzwgULOTnbY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)