UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k/GNm5WQGfdWDn+e8bf7YRvDmjDlY+/BYR+1SHulnO4='
WHERE
key_id = '7c7a454310566e0bbb8b2df63921b0722d198d033616510e5e10516ff8a99267'
AND (
token = 'k/GNm5WQGfdWDn+e8bf7YRvDmjDlY+/BYR+1SHulnO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)