UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JpzHQzp8mNecRXz+WIeFIerZnWzINaEtIo9cQ8ZNEg4='
WHERE
key_id = '27e50b0653e9d62b689b02d27aeba23848e2ef1247d583952b65f9e8ecd0e46c'
AND (
token = 'JpzHQzp8mNecRXz+WIeFIerZnWzINaEtIo9cQ8ZNEg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)