UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gVuM31d/Bipl4t1VdzOeeQvB69T2Fu2yB7wEMzcKZRg='
WHERE
key_id = '592059f7291550096d1bf29165e1e2b3adefe92801e89da0e93325ca697ee96b'
AND (
token = 'gVuM31d/Bipl4t1VdzOeeQvB69T2Fu2yB7wEMzcKZRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)