UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DKTIjeO1WMNkbms66Dn33poqf9nNJhpwHlUNG0EbVBw='
WHERE
key_id = '687257463a23b4a99dde181ad9c3ead757955f22f641fa7eeee29624f59a1152'
AND (
token = 'DKTIjeO1WMNkbms66Dn33poqf9nNJhpwHlUNG0EbVBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)