UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4rE5Pf8xDCSnSN4xU4JCmXvD2gHCCXjyRtxbGP9MKc='
WHERE
key_id = '16e61496b801d070f407b3ea2b3e132ba73defd49ee144e491b3bd5472638897'
AND (
token = 'G4rE5Pf8xDCSnSN4xU4JCmXvD2gHCCXjyRtxbGP9MKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)